-
This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports. Read more
-
This article describes how to import into DAX Studio the performance metrics that can be exported by the Power BI Performance Analyzer, simplifying the analysis of slower queries in a report. Read more
-
articleOptimizing text search in DAX
This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains condition in the filter pane or the filter mode of the Smart Filter Pro… Read more
-
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more
-
This article describes how to optimize a slow Power BI report with a large number of card visuals, by obtaining the same graphical layout with a smaller number of visuals. Read more
-
articleFields parameters in Power BI
This article analyzes the fields parameters feature in Power BI, unveiling some of the internals of its implementation. Read more
-
articleOptimizing DAX – second edition
The second edition of the Optimizing DAX video course is available: new content, a new book, and some on the behind-the-scenes of the project. Read more
-
Power BI introduced dynamic format strings in May 2023. In this article, we briefly introduce this functionality and then dive into a few technical details of its implementation. Read more
-
This article explains the roles of the formula engine and of the storage engine used to execute DAX queries. Read more
-
articleWelcome to SQLBI+
SQLBI+ is our new subscription service for advanced content that supports professional model authors who create semantic models for Power BI and Analysis Services. Read more